Value Property (Field Object)
The Value
property returns or sets the value of the Field object. Read/write.
Syntax
objField.Value
Data Type
Variant
Remarks
The value of
the Field object represents a value of the type specified by the Type
property. For example, when the Field object has the Type property vbBoolean,
the Value property can take the value TRUE or FALSE. When the Field
object has the Type property vbInteger, the Value property
can contain a short integer.
The Value
property is the default property of a Field object, meaning that Field is
syntactically equivalent to Field.Name in Visual Basic code.
Example
' fragment from function Field_Type()
' after validating the Field object objOneField
MsgBox
"Field type = " & objOneField.Type
' fragment from function Field_Value()...
MsgBox
"Field value = " & objOneField.Value
See Also
Type Property (Field Object)